Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
SalesRestrictionTypeCode (PK) | A unique, automatically assigned code for a specific limitation on an ITEM's sale. | TY_RST_SLS | Code2 | CHAR(2) | |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | RetailTransactionRestrictionValidation(NA_RTL_TRN_RSTRCTN_VLD) |
QuestionID (FK)(PK) | A unique identifer for the restriction validation question. | ID_QST_RST_VLD | Identity | integer | RetailTransactionRestrictionValidation(NA_RTL_TRN_RSTRCTN_VLD) |
ValidationResultFlag | A boolean indicator that tells if the customer's answer provided in response to a sales restriction question is accepted by the retailer or not. If yes the customer can purchase the restricted sale item. If NOT the retailer refused to sell the restricted sale item to a customer. Note that this is modeled at the transaction level because while rules are assigned at the line item level, restriction questions (and answers and validation results) happen at a transaction level. For example a retailer is not going to ask to verify a customer's age for each bottle of wine they are purchased. | FL_VLD_RSLT | Flag | integer | |